﻿IF db_id('AMAP') IS NOT NULL
DROP DATABASE AMAP
GO

CREATE DATABASE AMAP
GO

-- Create login lesmarrons for eponymous AMAP
IF NOT EXISTS 
    (SELECT name  
     FROM master.sys.server_principals
     WHERE name = 'lesmarrons')
BEGIN
    CREATE LOGIN [lesmarrons] WITH PASSWORD = N'123456'
END

